WIP Activity Net of Retainers

The WIP Activity Net of Retainers report shows WIP activity totals for a specified period, allowing you to review WIP activity for a selected date range. The report also includes progress bills generated and applied to the WIP and the beginning and ending WIP balance.

Permissions Required for this Report

In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:

• Security group profile > Functional rights > Reports > Shared Library > Shared Views
• Security group profile > Functional rights > Reports > Firm Library > Custom
• Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
• Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
• Security group profile > Functional rights > Reports > Firm Library > <report name>
• Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients

Reports in Foundation that are Comparable

In Practice Management, the comparable report is WIP Activity Net of Retainers. In Practice Advantage, there is no comparable report.

Report Specifications

The following report options and filters are available to determine the report contents.

Options and Settings
Option	Setting	Description
Select to Include Transactions Using…	List	Determines the type of transaction date to use. The options are Transaction Date and Accounting Period Date.
Hide Comma	Yes/No	Includes or excludes commas in numbers.
Hide Penny	Yes/No	Includes or excludes pennies in amounts.
Include Deleted Clients	Yes/No	Includes or excludes deleted client information.

Default Filters
Field Name	Operator	Value
PTD	Between	First Day of Current Month, Today
RTD	Between	First Day of Current Fiscal Year, Last Day of Current Fiscal Year

Notes:

• The PTD (period to date) fields may display values for a more limited period, such as a month or a quarter. The RTD (range to date) fields display values for a longer time span, such as a fiscal or calendar year. The date values entered for PTD must be within the RTD date values.
• If you remove the PTD and RTD fields and later decide they should be selected, use Reset Defaults to add these fields. If you manually add these fields, the logic statement used between the fields is AND instead of OR, causing inaccurate reporting data.

Optional Filters
Available Fields
Business Code	Client Type	PTD WIP Balance
Client	Financial Reporting Client Group	PTD WIP Beg Balance
Client – Principal	Line of Business	PTD WIP Write Up/Down
Client Bill Manager	Manager	Return Group
Client Business Unit	Primary Partner	RTD
Client ID	PTD	RTD % Relieved WIP Adjust
Client ID.Sub ID	PTD % Relieved WIP Adjust	RTD Billed Amounts
Client Name	PTD Billed Amounts	RTD Production Amounts
Client Office	PTD Production Amounts	RTD Progress Applied
Client Primary Service Type	PTD Progress Applied	RTD Progress Billed
Client Region	PTD Progress Billed	RTD WIP %
Client Sub ID	PTD WIP %	RTD WIP Balance
RTD WIP Beg Balance	RTD Write Up/Down	Tax Type
RTD WIP End Balance	Sort Name

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Grouping
Available Fields
Business Code	Client Name	Line of Business
Client	Client Office	Manager
Client – Principal	Client Primary Service Type	Primary Partner
Client Bill Manager	Client Region	Return Group
Client Business Unit	Client Sub ID	Sort Name
Client ID	Client Type	Tax Type
Client ID.Sub ID	Financial Reporting Client Group

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Sorting
Client

Report Fields

The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.

Report Fields
Field	Description
Client	The client name in Client Name (Client ID.Sub-ID) format.
WIP Beg Balance	The total of all open WIP as of the date range selected.
Production Amounts	The total of all billable WIP posted for the date range selected, including expenses and surcharges.
WIP Balance	The total WIP balance for the date range selected. The calculation is WIP beginning balance + production amounts.
Billed Amounts	The total of billed WIP amounts on posted invoices for the date ranged selected, including expenses and surcharges.
Write Up/Down	The total of all write up/down amounts for the date range selected.
Progress Billed	The total progress billed for the date range selected.
Progress Applied	The total progress applied for the date range selected.
WIP End Balance	The ending WIP balance for the date range selected. The calculation is WIP beginning balance + production amounts – billed amounts – progress billed + progress applied.
WIP %	The WIP percentage for the date range selected. The calculation is (billed amounts – write up/down – progress billed + progress applied)/WIP balance.
% Relieved WIP Adjust	The percentage of the relieved WIP adjustment for the date range selected. The calculation is write up/down/(billed amounts – write up/down – progress billed + progress applied).

WIP Activity Net of Retainers Sample Report